Rating Profiling Report

Dataset statistics

Number of variables	17
Number of observations	1000
Missing cells	2741
Missing cells (%)	16.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	682.9 KiB
Average record size in memory	699.3 B

Variable types

Numeric	7
Text	4
DateTime	1
Categorical	4
Unsupported	1

Alerts

`job` has 97 (9.7%) missing values	Missing
`postCode` has 1000 (100.0%) missing values	Missing
`didPurchase` has 292 (29.2%) missing values	Missing
`didRecommend` has 544 (54.4%) missing values	Missing
`isUsefull` has 801 (80.1%) missing values	Missing
`reviewid` is uniformly distributed	Uniform
`reviewid` has unique values	Unique
`postCode` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`ratingShipping` has 11 (1.1%) zeros	Zeros

Reproduction

Analysis started	2024-04-30 18:42:46.346018
Analysis finished	2024-04-30 18:42:55.491525
Duration	9.15 seconds
Software version	ydata-profiling vv4.7.0
Download configuration	config.json

reviewid
Real number (ℝ)

UNIFORM UNIQUE

Distinct	1000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	500.722

Minimum	1
Maximum	1001
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.9 KiB

Quantile statistics

Minimum	1
5-th percentile	50.95
Q1	250.75
median	500.5
Q3	750.25
95-th percentile	951.05
Maximum	1001
Range	1000
Interquartile range (IQR)	499.5

Descriptive statistics

Standard deviation	289.11888
Coefficient of variation (CV)	0.57740399
Kurtosis	-1.1993159
Mean	500.722
Median Absolute Deviation (MAD)	250
Skewness	0.0019987283
Sum	500722
Variance	83589.728
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	0.1%
672	1	0.1%
659	1	0.1%
660	1	0.1%
661	1	0.1%
662	1	0.1%
663	1	0.1%
664	1	0.1%
665	1	0.1%
666	1	0.1%
Other values (990)	990	99.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	0.1%
2	1	0.1%
3	1	0.1%
4	1	0.1%
5	1	0.1%
6	1	0.1%
7	1	0.1%
8	1	0.1%
9	1	0.1%
10	1	0.1%

Value	Count	Frequency (%)
1001	1	0.1%
1000	1	0.1%
999	1	0.1%
998	1	0.1%
997	1	0.1%
996	1	0.1%
995	1	0.1%
994	1	0.1%
993	1	0.1%
992	1	0.1%

productid
Real number (ℝ)

Distinct	288
Distinct (%)	28.8%
Missing	1
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	844.78278

Minimum	342
Maximum	999
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.9 KiB

Quantile statistics

Minimum	342
5-th percentile	714
Q1	774
median	842
Q3	922
95-th percentile	983.1
Maximum	999
Range	657
Interquartile range (IQR)	148

Descriptive statistics

Standard deviation	94.133374
Coefficient of variation (CV)	0.11142909
Kurtosis	2.5314517
Mean	844.78278
Median Absolute Deviation (MAD)	76
Skewness	-0.7231522
Sum	843938
Variance	8861.092
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
748	10	1.0%
785	9	0.9%
800	7	0.7%
993	7	0.7%
817	7	0.7%
762	7	0.7%
932	7	0.7%
804	7	0.7%
736	7	0.7%
904	7	0.7%
Other values (278)	924	92.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
342	1	0.1%
369	1	0.1%
376	1	0.1%
385	2	0.2%
394	1	0.1%
416	1	0.1%
571	1	0.1%
645	1	0.1%
680	4	0.4%
706	4	0.4%

Value	Count	Frequency (%)
999	3	0.3%
998	1	0.1%
997	2	0.2%
996	3	0.3%
995	4	0.4%
994	3	0.3%
993	7	0.7%
992	1	0.1%
991	5	0.5%
990	4	0.4%

ip
Text

Distinct	391
Distinct (%)	39.1%
Missing	1
Missing (%)	0.1%
Memory size	68.7 KiB

Length

Max length	15
Median length	14
Mean length	13.221221
Min length	10

Characters and Unicode

Total characters	13208
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	97 ?
Unique (%)	9.7%

Sample

1st row	235.254.248.5
2nd row	184.152.249.5
3rd row	187.190.241.112
4th row	5.140.171.130
5th row	178.84.50.74

Value	Count	Frequency (%)
84.48.127.221	9	0.9%
178.84.50.74	7	0.7%
171.155.141.188	7	0.7%
4.92.46.52	6	0.6%
160.34.193.167	6	0.6%
28.188.42.109	6	0.6%
176.220.174.95	6	0.6%
83.43.1.202	5	0.5%
149.47.105.185	5	0.5%
198.16.65.6	5	0.5%
Other values (381)	937	93.8%

Most occurring characters

Value	Count	Frequency (%)
.	2997	22.7%
1	2445	18.5%
2	1647	12.5%
5	915	6.9%
4	850	6.4%
9	788	6.0%
3	754	5.7%
7	749	5.7%
8	739	5.6%
6	663	5.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10211	77.3%
Other Punctuation	2997	22.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	2445	23.9%
2	1647	16.1%
5	915	9.0%
4	850	8.3%
9	788	7.7%
3	754	7.4%
7	749	7.3%
8	739	7.2%
6	663	6.5%
0	661	6.5%

Other Punctuation

Value	Count	Frequency (%)
.	2997	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	13208	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
.	2997	22.7%
1	2445	18.5%
2	1647	12.5%
5	915	6.9%
4	850	6.4%
9	788	6.0%
3	754	5.7%
7	749	5.7%
8	739	5.6%
6	663	5.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	13208	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
.	2997	22.7%
1	2445	18.5%
2	1647	12.5%
5	915	6.9%
4	850	6.4%
9	788	6.0%
3	754	5.7%
7	749	5.7%
8	739	5.6%
6	663	5.0%

date
Date

Distinct	338
Distinct (%)	33.8%
Missing	1
Missing (%)	0.1%
Memory size	7.9 KiB

Minimum	2011-01-01 00:00:00
Maximum	2011-12-30 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

ratingWebsite
Real number (ℝ)

Distinct	101
Distinct (%)	10.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.9669

Minimum	0
Maximum	10
Zeros	6
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	7.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0.6
Q1	2.6
median	4.7
Q3	7.5
95-th percentile	9.405
Maximum	10
Range	10
Interquartile range (IQR)	4.9

Descriptive statistics

Standard deviation	2.867727
Coefficient of variation (CV)	0.57736758
Kurtosis	-1.1891777
Mean	4.9669
Median Absolute Deviation (MAD)	2.4
Skewness	0.04475262
Sum	4966.9
Variance	8.2238582
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6.3	18	1.8%
3.8	16	1.6%
4	15	1.5%
0.7	15	1.5%
3.6	15	1.5%
8.7	15	1.5%
9.1	15	1.5%
4.5	15	1.5%
4.6	15	1.5%
3.7	14	1.4%
Other values (91)	847	84.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6	0.6%
0.1	8	0.8%
0.2	5	0.5%
0.3	13	1.3%
0.4	7	0.7%
0.5	10	1.0%
0.6	7	0.7%
0.7	15	1.5%
0.8	10	1.0%
0.9	13	1.3%

Value	Count	Frequency (%)
10	4	0.4%
9.9	12	1.2%
9.8	7	0.7%
9.7	12	1.2%
9.6	7	0.7%
9.5	8	0.8%
9.4	8	0.8%
9.3	10	1.0%
9.2	12	1.2%
9.1	15	1.5%

ratingShipping
Real number (ℝ)

ZEROS

Distinct	101
Distinct (%)	10.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.1123

Minimum	0
Maximum	10
Zeros	11
Zeros (%)	1.1%
Negative	0
Negative (%)	0.0%
Memory size	7.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0.395
Q1	2.6
median	5.3
Q3	7.6
95-th percentile	9.5
Maximum	10
Range	10
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	2.8966307
Coefficient of variation (CV)	0.56660029
Kurtosis	-1.1607925
Mean	5.1123
Median Absolute Deviation (MAD)	2.5
Skewness	-0.085864145
Sum	5112.3
Variance	8.3904692
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6.6	18	1.8%
5.9	17	1.7%
7.9	16	1.6%
3.3	16	1.6%
8.8	16	1.6%
4.1	15	1.5%
0.1	15	1.5%
6.5	15	1.5%
5.6	14	1.4%
8	14	1.4%
Other values (91)	844	84.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	11	1.1%
0.1	15	1.5%
0.2	12	1.2%
0.3	12	1.2%
0.4	10	1.0%
0.5	9	0.9%
0.6	5	0.5%
0.7	10	1.0%
0.8	6	0.6%
0.9	5	0.5%

Value	Count	Frequency (%)
10	3	0.3%
9.9	10	1.0%
9.8	12	1.2%
9.7	11	1.1%
9.6	8	0.8%
9.5	10	1.0%
9.4	13	1.3%
9.3	12	1.2%
9.2	13	1.3%
9.1	8	0.8%

ratingProduct
Real number (ℝ)

Distinct	91
Distinct (%)	9.1%
Missing	1
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	5.4437437

Minimum	1
Maximum	10
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.9 KiB

Quantile statistics

Minimum	1
5-th percentile	1.4
Q1	3.2
median	5.5
Q3	7.8000002
95-th percentile	9.3999996
Maximum	10
Range	9
Interquartile range (IQR)	4.6000002

Descriptive statistics

Standard deviation	2.6134496
Coefficient of variation (CV)	0.48008314
Kurtosis	-1.2211017
Mean	5.4437437
Median Absolute Deviation (MAD)	2.3000002
Skewness	-0.027954799
Sum	5438.3
Variance	6.8301186
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5.1999998	22	2.2%
1.5	18	1.8%
2	18	1.8%
5.5	18	1.8%
8	17	1.7%
8.3000002	16	1.6%
1.1	16	1.6%
7.8000002	16	1.6%
9.1999998	16	1.6%
7.1999998	16	1.6%
Other values (81)	826	82.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	9	0.9%
1.1	16	1.6%
1.2	9	0.9%
1.3	12	1.2%
1.4	7	0.7%
1.5	18	1.8%
1.6	10	1.0%
1.7	15	1.5%
1.8	14	1.4%
1.9	8	0.8%

Value	Count	Frequency (%)
10	5	0.5%
9.8999996	12	1.2%
9.8000002	9	0.9%
9.6999998	9	0.9%
9.6000004	8	0.8%
9.5	6	0.6%
9.3999996	9	0.9%
9.3000002	4	0.4%
9.1999998	16	1.6%
9.1000004	15	1.5%

ratingOverall
Real number (ℝ)

Distinct	84
Distinct (%)	8.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.1734

Minimum	0.7
Maximum	9.8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.9 KiB

Quantile statistics

Minimum	0.7
5-th percentile	2.6
Q1	4
median	5.2
Q3	6.3
95-th percentile	7.8
Maximum	9.8
Range	9.1
Interquartile range (IQR)	2.3

Descriptive statistics

Standard deviation	1.5813833
Coefficient of variation (CV)	0.30567583
Kurtosis	-0.29879677
Mean	5.1734
Median Absolute Deviation (MAD)	1.1
Skewness	-0.028353539
Sum	5173.4
Variance	2.5007732
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5.2	30	3.0%
6.4	28	2.8%
4	27	2.7%
4.7	27	2.7%
5.5	26	2.6%
5.4	26	2.6%
5.8	25	2.5%
4.8	25	2.5%
5.9	25	2.5%
6.1	25	2.5%
Other values (74)	736	73.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.7	1	0.1%
0.8	1	0.1%
1	1	0.1%
1.3	1	0.1%
1.4	1	0.1%
1.5	2	0.2%
1.6	3	0.3%
1.7	4	0.4%
1.8	4	0.4%
1.9	4	0.4%

Value	Count	Frequency (%)
9.8	1	0.1%
9.6	1	0.1%
9.4	1	0.1%
9.3	1	0.1%
9	2	0.2%
8.9	1	0.1%
8.8	3	0.3%
8.7	3	0.3%
8.6	2	0.2%
8.5	4	0.4%

gender
Categorical

Distinct	2
Distinct (%)	0.2%
Missing	1
Missing (%)	0.1%
Memory size	60.7 KiB

Female	507
Male	492

Length

Max length	6
Median length	6
Mean length	5.015015
Min length	4

Characters and Unicode

Total characters	5010
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Female
2nd row	Male
3rd row	Male
4th row	Male
5th row	Female

Common Values

Value	Count	Frequency (%)
Female	507	50.7%
Male	492	49.2%
(Missing)	1	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
female	507	50.8%
male	492	49.2%

Most occurring characters

Value	Count	Frequency (%)
e	1506	30.1%
a	999	19.9%
l	999	19.9%
F	507	10.1%
m	507	10.1%
M	492	9.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	4011	80.1%
Uppercase Letter	999	19.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1506	37.5%
a	999	24.9%
l	999	24.9%
m	507	12.6%

Uppercase Letter

Value	Count	Frequency (%)
F	507	50.8%
M	492	49.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5010	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1506	30.1%
a	999	19.9%
l	999	19.9%
F	507	10.1%
m	507	10.1%
M	492	9.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5010	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	1506	30.1%
a	999	19.9%
l	999	19.9%
F	507	10.1%
m	507	10.1%
M	492	9.8%

email
Text

Distinct	999
Distinct (%)	100.0%
Missing	1
Missing (%)	0.1%
Memory size	77.2 KiB

Length

Max length	37
Median length	33
Mean length	21.976977
Min length	14

Characters and Unicode

Total characters	21955
Distinct characters	39
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	999 ?
Unique (%)	100.0%

Sample

1st row	cmullarkey0@jimdo.com
2nd row	bhobben1@tamu.edu
3rd row	ringlesfield2@sourceforge.net
4th row	cgrogor3@wikipedia.org
5th row	tcashell4@ocn.ne.jp

Value	Count	Frequency (%)
cmullarkey0@jimdo.com	1	0.1%
lkleeweind@ucoz.ru	1	0.1%
pwahlbergu@elegantthemes.com	1	0.1%
ebodleyt@skype.com	1	0.1%
ringlesfield2@sourceforge.net	1	0.1%
cgrogor3@wikipedia.org	1	0.1%
tcashell4@ocn.ne.jp	1	0.1%
vmockler5@chicagotribune.com	1	0.1%
mpadula6@sourceforge.net	1	0.1%
welleray7@uiuc.edu	1	0.1%
Other values (989)	989	99.0%

Most occurring characters

Value	Count	Frequency (%)
o	1909	8.7%
e	1744	7.9%
c	1343	6.1%
a	1266	5.8%
m	1247	5.7%
r	1164	5.3%
.	1093	5.0%
i	1087	5.0%
n	1030	4.7%
@	999	4.6%
Other values (29)	9073	41.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	19173	87.3%
Other Punctuation	2092	9.5%
Decimal Number	669	3.0%
Dash Punctuation	21	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	1909	10.0%
e	1744	9.1%
c	1343	7.0%
a	1266	6.6%
m	1247	6.5%
r	1164	6.1%
i	1087	5.7%
n	1030	5.4%
l	990	5.2%
s	961	5.0%
Other values (16)	6432	33.5%

Decimal Number

Value	Count	Frequency (%)
1	79	11.8%
3	77	11.5%
2	76	11.4%
4	73	10.9%
8	71	10.6%
6	71	10.6%
9	64	9.6%
7	64	9.6%
5	64	9.6%
0	30	4.5%

Other Punctuation

Value	Count	Frequency (%)
.	1093	52.2%
@	999	47.8%

Dash Punctuation

Value	Count	Frequency (%)
-	21	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	19173	87.3%
Common	2782	12.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	1909	10.0%
e	1744	9.1%
c	1343	7.0%
a	1266	6.6%
m	1247	6.5%
r	1164	6.1%
i	1087	5.7%
n	1030	5.4%
l	990	5.2%
s	961	5.0%
Other values (16)	6432	33.5%

Common

Value	Count	Frequency (%)
.	1093	39.3%
@	999	35.9%
1	79	2.8%
3	77	2.8%
2	76	2.7%
4	73	2.6%
8	71	2.6%
6	71	2.6%
9	64	2.3%
7	64	2.3%
Other values (3)	115	4.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	21955	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	1909	8.7%
e	1744	7.9%
c	1343	6.1%
a	1266	5.8%
m	1247	5.7%
r	1164	5.3%
.	1093	5.0%
i	1087	5.0%
n	1030	4.7%
@	999	4.6%
Other values (29)	9073	41.3%

job
Text

MISSING

Distinct	179
Distinct (%)	19.8%
Missing	97
Missing (%)	9.7%
Memory size	69.8 KiB

Length

Max length	36
Median length	25
Mean length	18.604651
Min length	5

Characters and Unicode

Total characters	16800
Distinct characters	47
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	24 ?
Unique (%)	2.7%

Sample

1st row	Safety Technician IV
2nd row	Civil Engineer
3rd row	Research Associate
4th row	Payment Adjustment Coordinator
5th row	Environmental Specialist

Value	Count	Frequency (%)
engineer	122	5.7%
assistant	94	4.4%
manager	84	3.9%
analyst	66	3.1%
ii	65	3.0%
iii	61	2.8%
specialist	57	2.6%
systems	51	2.4%
i	50	2.3%
iv	49	2.3%
Other values (117)	1452	67.5%

Most occurring characters

Value	Count	Frequency (%)
e	1627	9.7%
t	1305	7.8%
a	1282	7.6%
i	1273	7.6%
n	1256	7.5%
	1248	7.4%
r	1082	6.4%
s	1043	6.2%
c	732	4.4%
o	705	4.2%
Other values (37)	5247	31.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	13092	77.9%
Uppercase Letter	2450	14.6%
Space Separator	1248	7.4%
Other Punctuation	10	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1627	12.4%
t	1305	10.0%
a	1282	9.8%
i	1273	9.7%
n	1256	9.6%
r	1082	8.3%
s	1043	8.0%
c	732	5.6%
o	705	5.4%
l	525	4.0%
Other values (14)	2262	17.3%

Uppercase Letter

Value	Count	Frequency (%)
I	445	18.2%
A	358	14.6%
S	315	12.9%
E	187	7.6%
P	174	7.1%
M	141	5.8%
C	134	5.5%
D	123	5.0%
V	91	3.7%
T	88	3.6%
Other values (11)	394	16.1%

Space Separator

Value	Count	Frequency (%)
	1248	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	10	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	15542	92.5%
Common	1258	7.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1627	10.5%
t	1305	8.4%
a	1282	8.2%
i	1273	8.2%
n	1256	8.1%
r	1082	7.0%
s	1043	6.7%
c	732	4.7%
o	705	4.5%
l	525	3.4%
Other values (35)	4712	30.3%

Common

Value	Count	Frequency (%)
	1248	99.2%
/	10	0.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	16800	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	1627	9.7%
t	1305	7.8%
a	1282	7.6%
i	1273	7.6%
n	1256	7.5%
	1248	7.4%
r	1082	6.4%
s	1043	6.2%
c	732	4.4%
o	705	4.2%
Other values (37)	5247	31.2%

postCode
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	1000
Missing (%)	100.0%
Memory size	7.9 KiB

source
Categorical

Distinct	8
Distinct (%)	0.8%
Missing	1
Missing (%)	0.1%
Memory size	61.4 KiB

Other	366
Bing	116
YouTube	99
Amazon	92
Twitter	91
Other values (3)	235

Length

Max length	8
Median length	7
Mean length	5.7237237
Min length	4

Characters and Unicode

Total characters	5718
Distinct characters	24
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Twitter
2nd row	Twitter
3rd row	Other
4th row	Other
5th row	TikTok

Common Values

Value	Count	Frequency (%)
Other	366	36.6%
Bing	116	11.6%
YouTube	99	9.9%
Amazon	92	9.2%
Twitter	91	9.1%
Google	88	8.8%
TikTok	81	8.1%
Facebook	66	6.6%
(Missing)	1	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
other	366	36.6%
bing	116	11.6%
youtube	99	9.9%
amazon	92	9.2%
twitter	91	9.1%
google	88	8.8%
tiktok	81	8.1%
facebook	66	6.6%

Most occurring characters

Value	Count	Frequency (%)
e	710	12.4%
o	580	10.1%
t	548	9.6%
r	457	8.0%
O	366	6.4%
h	366	6.4%
T	352	6.2%
i	288	5.0%
k	228	4.0%
n	208	3.6%
Other values (14)	1615	28.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	4539	79.4%
Uppercase Letter	1179	20.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	710	15.6%
o	580	12.8%
t	548	12.1%
r	457	10.1%
h	366	8.1%
i	288	6.3%
k	228	5.0%
n	208	4.6%
g	204	4.5%
u	198	4.4%
Other values (7)	752	16.6%

Uppercase Letter

Value	Count	Frequency (%)
O	366	31.0%
T	352	29.9%
B	116	9.8%
Y	99	8.4%
A	92	7.8%
G	88	7.5%
F	66	5.6%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5718	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	710	12.4%
o	580	10.1%
t	548	9.6%
r	457	8.0%
O	366	6.4%
h	366	6.4%
T	352	6.2%
i	288	5.0%
k	228	4.0%
n	208	3.6%
Other values (14)	1615	28.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5718	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	710	12.4%
o	580	10.1%
t	548	9.6%
r	457	8.0%
O	366	6.4%
h	366	6.4%
T	352	6.2%
i	288	5.0%
k	228	4.0%
n	208	3.6%
Other values (14)	1615	28.2%

didPurchase
Categorical

MISSING

Distinct	2
Distinct (%)	0.3%
Missing	292
Missing (%)	29.2%
Memory size	59.3 KiB

0	412
TRUE	296

Length

Max length	4
Median length	1
Mean length	2.2542373
Min length	1

Characters and Unicode

Total characters	1596
Distinct characters	5
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	TRUE
2nd row	TRUE
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	412	41.2%
TRUE	296	29.6%
(Missing)	292	29.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	412	58.2%
true	296	41.8%

Most occurring characters

Value	Count	Frequency (%)
0	412	25.8%
T	296	18.5%
R	296	18.5%
U	296	18.5%
E	296	18.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1184	74.2%
Decimal Number	412	25.8%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
T	296	25.0%
R	296	25.0%
U	296	25.0%
E	296	25.0%

Decimal Number

Value	Count	Frequency (%)
0	412	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1184	74.2%
Common	412	25.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
T	296	25.0%
R	296	25.0%
U	296	25.0%
E	296	25.0%

Common

Value	Count	Frequency (%)
0	412	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1596	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	412	25.8%
T	296	18.5%
R	296	18.5%
U	296	18.5%
E	296	18.5%

didRecommend
Categorical

MISSING

Distinct	2
Distinct (%)	0.4%
Missing	544
Missing (%)	54.4%
Memory size	60.8 KiB

1.0	397
0.0	59

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	1368
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	1.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	397	39.7%
0.0	59	5.9%
(Missing)	544	54.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.0	397	87.1%
0.0	59	12.9%

Most occurring characters

Value	Count	Frequency (%)
0	515	37.6%
.	456	33.3%
1	397	29.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	912	66.7%
Other Punctuation	456	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	515	56.5%
1	397	43.5%

Other Punctuation

Value	Count	Frequency (%)
.	456	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1368	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	515	37.6%
.	456	33.3%
1	397	29.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1368	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	515	37.6%
.	456	33.3%
1	397	29.0%

isUsefull
Real number (ℝ)

MISSING

Distinct	26
Distinct (%)	13.1%
Missing	801
Missing (%)	80.1%
Infinite	0
Infinite (%)	0.0%
Mean	11.763819

Minimum	0
Maximum	25
Zeros	4
Zeros (%)	0.4%
Negative	0
Negative (%)	0.0%
Memory size	7.9 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	5
median	11
Q3	18
95-th percentile	23
Maximum	25
Range	25
Interquartile range (IQR)	13

Descriptive statistics

Standard deviation	7.5531449
Coefficient of variation (CV)	0.64206571
Kurtosis	-1.3314302
Mean	11.763819
Median Absolute Deviation (MAD)	7
Skewness	0.10979186
Sum	2341
Variance	57.049997
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=26)

Value	Count	Frequency (%)
7	14	1.4%
1	13	1.3%
23	12	1.2%
2	11	1.1%
17	11	1.1%
9	10	1.0%
5	10	1.0%
8	9	0.9%
4	9	0.9%
18	8	0.8%
Other values (16)	92	9.2%
(Missing)	801	80.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4	0.4%
1	13	1.3%
2	11	1.1%
3	8	0.8%
4	9	0.9%
5	10	1.0%
6	4	0.4%
7	14	1.4%
8	9	0.9%
9	10	1.0%

Value	Count	Frequency (%)
25	2	0.2%
24	7	0.7%
23	12	1.2%
22	6	0.6%
21	7	0.7%
20	8	0.8%
19	7	0.7%
18	8	0.8%
17	11	1.1%
16	7	0.7%

userAgent
Text

Distinct	420
Distinct (%)	42.0%
Missing	0
Missing (%)	0.0%
Memory size	160.7 KiB

Length

Max length	244
Median length	133
Mean length	107.449
Min length	47

Characters and Unicode

Total characters	107449
Distinct characters	72
Distinct categories	10 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	116 ?
Unique (%)	11.6%

Sample

1st row	Mozilla/5.0 (Windows NT 6.1; rv:12.0) Gecko/20120403211507 Firefox/12.0
2nd row	Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/535.11 (KHTML, like Gecko) Chrome/17.0.963.66 Safari/535.11
3rd row	Mozilla/5.0 (Windows NT 5.1) AppleWebKit/534.24 (KHTML, like Gecko) Chrome/11.0.700.3 Safari/534.24
4th row	Mozilla/5.0 (X11; Linux x86_64; rv:28.0) Gecko/20100101 Firefox/28.0
5th row	Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.93 Safari/537.36

Value	Count	Frequency (%)
mozilla/5.0	999	8.7%
like	858	7.5%
gecko	841	7.3%
khtml	831	7.2%
windows	581	5.1%
nt	471	4.1%
os	314	2.7%
mac	287	2.5%
x	287	2.5%
macintosh	260	2.3%
Other values (524)	5740	50.0%

Most occurring characters

Value	Count	Frequency (%)
	10469	9.7%
.	6358	5.9%
i	5193	4.8%
e	5051	4.7%
1	4226	3.9%
o	4023	3.7%
5	4018	3.7%
0	4006	3.7%
l	3997	3.7%
/	3994	3.7%
Other values (62)	56114	52.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	40628	37.8%
Decimal Number	23022	21.4%
Uppercase Letter	15792	14.7%
Other Punctuation	12905	12.0%
Space Separator	10469	9.7%
Close Punctuation	1837	1.7%
Open Punctuation	1837	1.7%
Connector Punctuation	664	0.6%
Dash Punctuation	258	0.2%
Math Symbol	37	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	5193	12.8%
e	5051	12.4%
o	4023	9.9%
l	3997	9.8%
a	3313	8.2%
r	2166	5.3%
k	1882	4.6%
n	1783	4.4%
p	1713	4.2%
c	1610	4.0%
Other values (16)	9897	24.4%

Uppercase Letter

Value	Count	Frequency (%)
M	2410	15.3%
W	1713	10.8%
K	1665	10.5%
T	1331	8.4%
S	1278	8.1%
L	1037	6.6%
G	1016	6.4%
A	855	5.4%
H	838	5.3%
C	787	5.0%
Other values (14)	2862	18.1%

Decimal Number

Value	Count	Frequency (%)
1	4226	18.4%
5	4018	17.5%
0	4006	17.4%
3	2981	12.9%
6	2075	9.0%
2	1861	8.1%
4	1599	6.9%
7	1019	4.4%
8	762	3.3%
9	475	2.1%

Other Punctuation

Value	Count	Frequency (%)
.	6358	49.3%
/	3994	30.9%
;	1549	12.0%
,	828	6.4%
:	174	1.3%
!	2	< 0.1%

Space Separator

Value	Count	Frequency (%)
	10469	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	1837	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	1837	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	664	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	258	100.0%

Math Symbol

Value	Count	Frequency (%)
+	37	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	56420	52.5%
Common	51029	47.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	5193	9.2%
e	5051	9.0%
o	4023	7.1%
l	3997	7.1%
a	3313	5.9%
M	2410	4.3%
r	2166	3.8%
k	1882	3.3%
n	1783	3.2%
p	1713	3.0%
Other values (40)	24889	44.1%

Common

Value	Count	Frequency (%)
	10469	20.5%
.	6358	12.5%
1	4226	8.3%
5	4018	7.9%
0	4006	7.9%
/	3994	7.8%
3	2981	5.8%
6	2075	4.1%
2	1861	3.6%
)	1837	3.6%
Other values (12)	9204	18.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	107449	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	10469	9.7%
.	6358	5.9%
i	5193	4.8%
e	5051	4.7%
1	4226	3.9%
o	4023	3.7%
5	4018	3.7%
0	4006	3.7%
l	3997	3.7%
/	3994	3.7%
Other values (62)	56114	52.2%

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	reviewid	productid	ip	date	ratingWebsite	ratingShipping	ratingProduct	ratingOverall	gender	email	job	postCode	source	didPurchase	didRecommend	isUsefull	userAgent
0	1	748.0	235.254.248.5	10/08/2011	3.7	5.9	7.6	5.7	Female	cmullarkey0@jimdo.com	Safety Technician IV	NaN	Twitter	TRUE	1.0	NaN	Mozilla/5.0 (Windows NT 6.1; rv:12.0) Gecko/20120403211507 Firefox/12.0
1	2	804.0	184.152.249.5	10/11/2011	2.7	8.2	1.1	4.0	Male	bhobben1@tamu.edu	Civil Engineer	NaN	Twitter	TRUE	NaN	18.0	Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/535.11 (KHTML, like Gecko) Chrome/17.0.963.66 Safari/535.11
2	3	781.0	187.190.241.112	8/05/2011	0.9	9.1	8.5	6.2	Male	ringlesfield2@sourceforge.net	Research Associate	NaN	Other	0	1.0	NaN	Mozilla/5.0 (Windows NT 5.1) AppleWebKit/534.24 (KHTML, like Gecko) Chrome/11.0.700.3 Safari/534.24
3	4	779.0	5.140.171.130	10/23/2011	1.6	5.2	4.5	3.8	Male	cgrogor3@wikipedia.org	NaN	NaN	Other	0	NaN	NaN	Mozilla/5.0 (X11; Linux x86_64; rv:28.0) Gecko/20100101 Firefox/28.0
4	5	835.0	178.84.50.74	1/14/2011	9.4	1.3	7.8	6.2	Female	tcashell4@ocn.ne.jp	Payment Adjustment Coordinator	NaN	TikTok	0	1.0	NaN	Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.93 Safari/537.36
5	6	941.0	83.43.1.202	3/26/2011	4.3	2.9	1.1	2.8	Female	vmockler5@chicagotribune.com	Environmental Specialist	NaN	Other	NaN	NaN	2.0	Mozilla/5.0 (Windows NT 5.1) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/14.0.813.0 Safari/535.1
6	7	890.0	116.167.31.94	8/29/2011	6.6	4.5	4.6	5.2	Male	mpadula6@sourceforge.net	NaN	NaN	Other	0	NaN	NaN	Mozilla/5.0 (Windows NT 6.2; rv:22.0) Gecko/20130405 Firefox/22.0
7	8	938.0	102.142.18.100	4/03/2011	1.2	6.1	5.5	4.3	Male	welleray7@uiuc.edu	NaN	NaN	Other	0	NaN	NaN	Mozilla/5.0 (Windows NT 6.1; WOW64; rv:23.0) Gecko/20130406 Firefox/23.0
8	9	831.0	9.205.252.30	5/24/2011	0.7	9.0	9.2	6.3	Female	rdanielsen8@upenn.edu	Recruiting Manager	NaN	Google	0	1.0	1.0	Mozilla/5.0 (Macintosh; U; PPC Mac OS X 10_4_11; tr) AppleWebKit/528.4+ (KHTML, like Gecko) Version/4.0dp1 Safari/526.11.2
9	10	852.0	4.92.46.52	3/29/2011	5.2	8.4	7.2	6.9	Female	deastridge9@weather.com	Accountant III	NaN	Bing	TRUE	1.0	NaN	Mozilla/5.0 (Windows NT 6.2; Win64; x64; rv:16.0.1) Gecko/20121011 Firefox/21.0.1

	reviewid	productid	ip	date	ratingWebsite	ratingShipping	ratingProduct	ratingOverall	gender	email	job	postCode	source	didPurchase	didRecommend	isUsefull	userAgent
990	992	785.0	142.85.186.193	3/30/2011	8.7	4.5	5.3	6.2	Male	dfaasrj@bbc.co.uk	Physical Therapy Assistant	NaN	Other	TRUE	NaN	NaN	Mozilla/5.0 (X11; Linux i686; rv:21.0) Gecko/20100101 Firefox/21.0
991	993	807.0	180.255.115.97	12/19/2011	2.8	1.9	8.7	4.5	Female	cdunkerleyrk@webmd.com	Editor	NaN	Other	NaN	NaN	21.0	Mozilla/5.0 (Windows; U; Windows NT 5.1; ru-RU) AppleWebKit/533.18.1 (KHTML, like Gecko) Version/5.0.2 Safari/533.18.5
992	994	847.0	179.189.57.156	5/08/2011	3.4	2.1	8.8	4.8	Female	gtomasinorl@networksolutions.com	Technical Writer	NaN	TikTok	NaN	1.0	11.0	Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.47 Safari/537.36
993	995	916.0	42.245.196.86	3/07/2011	9.1	3.3	1.7	4.7	Male	mbartellrm@cbslocal.com	Web Developer IV	NaN	Other	TRUE	NaN	NaN	Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.13 (KHTML, like Gecko) Chrome/24.0.1290.1 Safari/537.13
994	996	806.0	65.32.13.1	8/19/2011	9.8	2.9	4.6	5.8	Female	hmccartrn@admin.ch	General Manager	NaN	Facebook	0	NaN	NaN	Mozilla/5.0 (Windows NT 6.1; en-US) AppleWebKit/534.30 (KHTML, like Gecko) Chrome/12.0.750.0 Safari/534.30
995	997	917.0	41.184.101.23	8/01/2011	3.2	9.7	2.9	5.3	Female	lhuchotro@twitpic.com	Computer Systems Analyst IV	NaN	Bing	NaN	0.0	NaN	Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.1.16) Gecko/20120421 Firefox/11.0
996	998	754.0	197.50.161.225	12/20/2011	8.4	1.7	6.3	5.5	Male	lbilofskyrp@1688.com	NaN	NaN	Twitter	NaN	1.0	NaN	Mozilla/5.0 (Macintosh; U; PPC Mac OS X 10.5; en-US; rv:1.9.1b3pre) Gecko/20081212 Mozilla/5.0 (Windows; U; Windows NT 5.1; en) AppleWebKit/526.9 (KHTML, like Gecko) Version/4.0dp1 Safari/526.8
997	999	904.0	245.91.225.126	2/12/2011	2.9	1.4	2.0	2.1	Male	bwogdonrq@hp.com	Systems Administrator IV	NaN	Facebook	0	NaN	NaN	Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/13.0.782.220 Safari/535.1
998	1000	962.0	86.147.224.117	5/16/2011	4.2	8.7	4.6	5.8	Female	pkamanrr@ox.ac.uk	Physical Therapy Assistant	NaN	YouTube	TRUE	NaN	NaN	Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_6_3; zh-cn) AppleWebKit/533.16 (KHTML, like Gecko) Version/5.0 Safari/533.16
999	1001	NaN	NaN	NaN	0.3	1.3	NaN	0.8	NaN	NaN	Nurse Practicioner	NaN	NaN	NaN	NaN	NaN	Mozilla/5.0 (Windows NT 5.0; rv:21.0) Gecko/20100101 Firefox/21.0

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Decimal Number

Other Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin